<?php 
$reqPath='';
//require_once("include/authen.php");
require_once($reqPath."class/m_report.php");
require_once($reqPath.'fpdf/fpdf.php');

$datefrom = $_POST['dFrom'];
$dateto = $_POST['dTo'];

class PDF extends FPDF
{
	var $datefrom;
	var $dateto;
	
	function setHeaderCriteria($dtfrom , $dtto){
		$this->datefrom=$dtfrom;
		$this->dateto=$dtto;
	}
	function Header()
	{
		//Arial bold 15
		$this->SetFont('tahoma','B',12);
		//Title
		$this->Cell(0,10,iconv( 'UTF-8','cp874' , 'รายงานสินค้าคืน - ชำรุด'),0,0,'C');
		$this->Ln(5);
		$this->SetFont('tahoma','B',11);
		$this->Cell(0,10,iconv( 'UTF-8','cp874' , 'ข้อมูลตั้งแต่วันที่ '. $this->datefrom .' ถึง '. $this->dateto),0,0,'C');
		//Line break
		$this->Ln(15);
	}

	//Page footer
	function Footer()
	{
		//Position at 1.5 cm from bottom
		$this->SetY(-15);
		//Arial italic 8
		$this->SetFont('Arial','I',8);
		//Page number
		$this->Cell(0,10,'Page '.$this->PageNo().'/{nb}',0,0,'R');
	}
	
	//Colored table
	function GenTable($header,$data=null)
	{
		$bln ="";
		 $w=array(15,25,90,35,30);
		//header
		$fill=false;
		$i=1;
		foreach ($data as $h){
			$this->SetTextColor(0);
			if ($bln != $h["BranchName"]){
				$this->SetFont('','B');
				$this->Cell(array_sum($w),6, iconv( 'UTF-8','cp874' , "สาขา   " . $h["BranchName"] ),'',0,'L',false);
				$this->Ln();
				$bln = $h["BranchName"];
					//Colors, line width and bold font
				$this->SetFillColor(20,114,218);
				$this->SetTextColor(255);
				$this->SetDrawColor(114,175,242);
				$this->SetLineWidth(.1);
				$this->SetFont('','B');
				for($i=0;$i<count($header);$i++){
					$this->Cell($w[$i],7,iconv( 'UTF-8','cp874' , $header[$i]),1,0,'C',true);
				}	
				$this->Ln();
				$i=1;
				$fill=false;
			}
			//Color and font restoration
			$this->SetFillColor(224,235,255);
			$this->SetTextColor(0);
			$this->SetFont('');
			//detail

			$this->Cell($w[0],6,$i,'L',0,'R',$fill);
			$this->Cell($w[1],6,$h['_ReturnDate'],'L',0,'C',$fill);
			$this->Cell($w[2],6,iconv( 'UTF-8','cp874' , $h['ProductName']),'L',0,'L',$fill);
			$this->Cell($w[3],6,$h['Type'],'LR',0,'C',$fill);
			$this->Cell($w[4],6, number_format($h['Amounts_r'],0,'.',','),'LR',0,'C',$fill);
			$this->Ln();
			$fill=!$fill;
			$i++;		

	
			// AddPage();
		}
		$this->Cell(array_sum($w),0,'','T');
		$this->Ln(15);
 
	}
 }
if (!(isset($_POST['dFrom']))) {
	header("location:report_return_product.php");
	
}

list($day, $month, $year) = split('/', $datefrom);
$c_from =$year."/".$month."/".$day;

list($day, $month, $year) = split('/', $dateto);
$c_to =$year."/".$month."/".$day;

$branch = $_POST['branch'];
$type = $_POST['type'];
 
$report=new M_report();
$header=$report->ReturnHeader(); 
$data=$report->ReturnReport($c_from, $c_to, $branch,$type);
 if (count($data)==0){
	echo "<script>alert('Data not found');window.close();</script>";
	exit();
}
$pdf=new PDF();
$pdf->setHeaderCriteria($datefrom,$dateto);
$pdf->SetRightMargin(5);
$pdf->SetLeftMargin(5);
//Set pageno
$pdf->AliasNbPages();
$pdf->AddFont("tahoma","","tahoma.php");
$pdf->AddFont("tahoma","B","tahomab.php");

$pdf->SetFont("tahoma","B",10); 
$pdf->SetFont("tahoma","",10); 

//Data loading
$pdf->AddPage();
$pdf->GenTable($header,$data );
$pdf->Output();
exit();
?>
